package com.ssl.ware.repo;

import com.ssl.ware.pojo.Freight;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface FreightRepo extends JpaRepository<Freight, Long> {
    @Query(value = "select * from freight where shop_id =?1 and template_name in ?2", nativeQuery = true)
    List<Freight> getByShopIdAndTemplateNameIn(Integer shopId, List<String> templateNames);
}
